Quản lý nhân sự công ty bằng c# _ full source code
60.456 lượt xem;
- frmtracuutrinhdo.cs
- QuanLyNhanSu /
- project /
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Text;
7 using System.Windows.Forms;
8 using System.Data.SqlClient;
9 using QuanLyNhanSu.Class;
10 using Telerik.WinControls;
11
12
13 namespace QuanLyNhanSu
14 {
15 public partial class frmtracuutrinhdo : RadForm
16 {
17 //khai báo biến toàn cục
18 clsdmchuyenmon cdmcm = new clsdmchuyenmon();
19 clsdmtrinhdo cdmtd = new clsdmtrinhdo();
20 clsdmngoaingu cdmnn = new clsdmngoaingu();
21 clstimtttrinhdo c = new clstimtttrinhdo();
22 clstimngoaingu cnn = new clstimngoaingu();
23 static public string dk = "";
24 public frmtracuutrinhdo()
25 {
26 InitializeComponent();
27 cbodmcm.DataSource = cdmcm.taocombocm();
28 cbodmcm.DisplayMember = "TenChuyenMon";
29 cbodmcm.ValueMember = "MaChuyenMon";
30 cbodmnn.DataSource = cdmnn.taocombonn();
31 cbodmnn.DisplayMember = "TenNgoaiNgu";
32 cbodmnn.ValueMember = "MaNgoaiNgu";
33 cbodmtd.DataSource = cdmtd.taocombotd();
34 cbodmtd.DisplayMember = "TenTrinhDo";
35 cbodmtd.ValueMember = "MaTrinhDo";
36 dgv_TCTD1.DataSource = c.laydl();
37 dgv_TCTD1.DataMember = "TC_TrinhDo";
38 dgv_NV_NN.DataSource = cnn.laydl();
39 dgv_NV_NN.DataMember = "TC_NN";
40
41
42 }
43
44 private void frmtracuutrinhdo_Load(object sender, EventArgs e)
45 {
46 dk = "";
47 }
48
49 private void cmdtim_Click(object sender, EventArgs e)
50 {
51 dk ="";
52 if (cbodmcm.SelectedItem != null)
53 dk = dk + " machuyenmon like " + int.Parse(cbodmcm.SelectedValue.ToString());
54 if(cbodmtd.SelectedItem != null)
55 dk = dk +" and matrinhdo like "+ int.Parse(cbodmtd.SelectedValue.ToString());
56 if (txttruongcap.Text != "")
57 dk = dk + " and truong like N'" + txttruongcap.Text.Trim() + "%'";
58 if (dk == "")
59 {
60 dgv_TCTD1.DataSource = c.laydl();
61 dgv_TCTD1.DataMember = "TC_TrinhDo";
62 }
63 else
64 {
65 if (dk.Substring(0, 4) == " and")
66 dk = dk.Substring(5);
67 dgv_TCTD1.DataSource = c.laydl(dk);
68 dgv_TCTD1.DataMember = "TC_TrinhDo";
69 }
70 }
71
72 private void cmdnntim_Click(object sender, EventArgs e)
73 {
74 string dk = "";
75 if (cbodmnn.SelectedItem!= null)
76 dk = dk + " mangoaingu like " + int.Parse(cbodmnn.SelectedValue.ToString()) ;
77 if (txttrinhdo .Text != "")
78 dk = dk + " and trinhdo like N'" + txttrinhdo.Text.Trim()+"%'";
79 if (txtnoicap.Text != "")
80 dk = dk + " and noicap like N'" + txtnoicap.Text.Trim() + "%'";
81 if (dk == "")
82 {
83 dgv_NV_NN.DataSource = cnn.laydl();
84 dgv_NV_NN.DataMember = "TC_NN";
85 }
86 else
87 {
88 if (dk.Substring(0, 4) == " and")
89 dk = dk.Substring(5);
90 dgv_NV_NN.DataSource = cnn.laydl(dk);
91 dgv_NV_NN.DataMember = "TC_NN";
92 }
93 }
94
95
96
97 }
98 }
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Text;
7 using System.Windows.Forms;
8 using System.Data.SqlClient;
9 using QuanLyNhanSu.Class;
10 using Telerik.WinControls;
11
12
13 namespace QuanLyNhanSu
14 {
15 public partial class frmtracuutrinhdo : RadForm
16 {
17 //khai báo biến toàn cục
18 clsdmchuyenmon cdmcm = new clsdmchuyenmon();
19 clsdmtrinhdo cdmtd = new clsdmtrinhdo();
20 clsdmngoaingu cdmnn = new clsdmngoaingu();
21 clstimtttrinhdo c = new clstimtttrinhdo();
22 clstimngoaingu cnn = new clstimngoaingu();
23 static public string dk = "";
24 public frmtracuutrinhdo()
25 {
26 InitializeComponent();
27 cbodmcm.DataSource = cdmcm.taocombocm();
28 cbodmcm.DisplayMember = "TenChuyenMon";
29 cbodmcm.ValueMember = "MaChuyenMon";
30 cbodmnn.DataSource = cdmnn.taocombonn();
31 cbodmnn.DisplayMember = "TenNgoaiNgu";
32 cbodmnn.ValueMember = "MaNgoaiNgu";
33 cbodmtd.DataSource = cdmtd.taocombotd();
34 cbodmtd.DisplayMember = "TenTrinhDo";
35 cbodmtd.ValueMember = "MaTrinhDo";
36 dgv_TCTD1.DataSource = c.laydl();
37 dgv_TCTD1.DataMember = "TC_TrinhDo";
38 dgv_NV_NN.DataSource = cnn.laydl();
39 dgv_NV_NN.DataMember = "TC_NN";
40
41
42 }
43
44 private void frmtracuutrinhdo_Load(object sender, EventArgs e)
45 {
46 dk = "";
47 }
48
49 private void cmdtim_Click(object sender, EventArgs e)
50 {
51 dk ="";
52 if (cbodmcm.SelectedItem != null)
53 dk = dk + " machuyenmon like " + int.Parse(cbodmcm.SelectedValue.ToString());
54 if(cbodmtd.SelectedItem != null)
55 dk = dk +" and matrinhdo like "+ int.Parse(cbodmtd.SelectedValue.ToString());
56 if (txttruongcap.Text != "")
57 dk = dk + " and truong like N'" + txttruongcap.Text.Trim() + "%'";
58 if (dk == "")
59 {
60 dgv_TCTD1.DataSource = c.laydl();
61 dgv_TCTD1.DataMember = "TC_TrinhDo";
62 }
63 else
64 {
65 if (dk.Substring(0, 4) == " and")
66 dk = dk.Substring(5);
67 dgv_TCTD1.DataSource = c.laydl(dk);
68 dgv_TCTD1.DataMember = "TC_TrinhDo";
69 }
70 }
71
72 private void cmdnntim_Click(object sender, EventArgs e)
73 {
74 string dk = "";
75 if (cbodmnn.SelectedItem!= null)
76 dk = dk + " mangoaingu like " + int.Parse(cbodmnn.SelectedValue.ToString()) ;
77 if (txttrinhdo .Text != "")
78 dk = dk + " and trinhdo like N'" + txttrinhdo.Text.Trim()+"%'";
79 if (txtnoicap.Text != "")
80 dk = dk + " and noicap like N'" + txtnoicap.Text.Trim() + "%'";
81 if (dk == "")
82 {
83 dgv_NV_NN.DataSource = cnn.laydl();
84 dgv_NV_NN.DataMember = "TC_NN";
85 }
86 else
87 {
88 if (dk.Substring(0, 4) == " and")
89 dk = dk.Substring(5);
90 dgv_NV_NN.DataSource = cnn.laydl(dk);
91 dgv_NV_NN.DataMember = "TC_NN";
92 }
93 }
94
95
96
97 }
98 }